package com.example.mapper.configuration;

import com.example.bean.configuration.PingGuJiBieGuanLi;
import com.example.bean.configuration.vo.PingGuJiBieGuanLiVo;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface PingGuJiBieGuanLiMapper {

    List<PingGuJiBieGuanLi> getpage(PingGuJiBieGuanLiVo vo);

    Integer addpgjbgl(PingGuJiBieGuanLi pingGuJiBieGuanLi);
    @Select("select jibie.*, moban.moban_name from jibie left join moban on jibie.moban_id = moban.noid where jibie.noid = #{aid}")
    PingGuJiBieGuanLi getId(String aid);
    @Update("update jibie set moban_id = #{mobanid}, pinggu_jibie = #{pinggujibie}, min = #{min}, max = #{max}, update_date = #{updatedate} where noid = #{noid}")
    Integer xiugai(PingGuJiBieGuanLi pingGuJiBieGuanLi);

    Integer dels(List<String> ids);
}
